Anito.net is an under development, simple, open source Object Relational Mapping framework for .Net that aims to speed up database-driven development through reusable patterns and database independent solutions. Supported database MS-SQL, MySQL, SQLite and MongoDB
Application Box for ExtAsp.net.
http://arachnode.net 2.6 release +lucene.net
Web based interface for automatic adding and updating of sql server 2005 table columns' ext pros on any of the databases an SQL server login account has access to. Lists all stored procedures of the chosen database and shows their content. Generates stored procedures per table
T-SQL code-gen script for audit trail triggers for SQL Server 2005-2012. Logs what, when, where, who & how SQL data and objects were created, modified & deleted
Here's project that enables any developers or others to run the big sql script file greater than 300MB or any size. It also supports rollback feature & others.
A suite of applications (web and client based) including a database used in to create/view/modify decks and rulings with the Yu-Gi-Oh! trading card game. Data is structured to be expandable into other collectible card games (CCGs). Uses SQL 2005, WinForms, ASP.Net AJAX, WPF.
Credit Card Number Validator 05 (CCNV05) is a Custom SSIS Data Flow Transformation Component that determines whether the given input is a valid credit card number or not. CCNV05 takes String/Numeric input and performs a Synchronous, Non-Blocking transformation using Luhn Mod 10 a
The Central Database Administration project is a combination of a management database for all SQL instances and a central data warehouse for management and monitoring. It uses as much built-in functionality as possible - such as MSX, SSRS, SSIS, etc. Automate at least 1 FTE.
A tool to assist a development team rapidly prototype a DataModel.
OOP Data Access Layer for .net 2.0
Database Unit Testing with C# and NUnit. DatabaseUnitTesting
A Basic .Net application that will connect to a SQL Server, allow you to select a database, then select from the user created tables, read the table information, and will build the asp.net code to insert and update records. Written in VB with plans for C#
This framework provides factory components for connecting and working with databases. The factory components provide the ability to work with many kinds of databases without requiring database platform-specific code. Also, this framework provides support for object-relational mapping of business objects to database information.
There are lots of great applications to script out and find differences in SQL Server schemas. What I think is missing is a flexible tool to reassemble your scripts and deploy them easily. This tool provides a means of combining the scripts into a single SQL file or have them run against a database in an order you specify. There is also an option for keeping track of which scripts have been applied to a database to help deploy schema changes in a much easier way.
Simple tool to copy databases from one SQL Server to another.
Compare MSSql database structures. (Sql 2005, Sql 2008, Sql 2008R2, Sql Denali ) Features: - compare database structures - scripting without dmo or smo - commandline scripting, commandline compare - standalone dll-s for referencing
DBSourceTools is a GUI utility to help developers bring SQL Server databases under source control. A powerful database scripter, code editor, sql generator, and database versioning tool. Compare Schemas, create diff scripts, edit T-SQL with ease. Better than Management Studio.
DSQLT - Dynamic SQL Templates Use Stored Procedures as templates for dynamic SQL statements. Substitute parameters @0-@9 with values like objectnames or list of columnnames. Iterate over cursor-resultset instead of constant values. Write object-independent algorithms in T-SQL.
Employee Info Starter Kit is an open source project that is highly influenced by the concept ‘Pareto Principle’ or 80-20 rule, where it is targeted to enable a web developer to gain 80% productivity with 20% of effort with respect to learning curve and production.